Release 10.1A: OpenEdge Data Management:
SQL Reference


SYSDATATYPES

Contains information on each data type supported by the database.

Table 13 provides details of the SYSDATATYPES table.

Table 13: SYSDATATYPES system table 
Column name
Column data type
Column size
autoincr
SMALLINT
2
casesensitive
SMALLINT
2
createparams
VARCHAR
32
datatype
SMALLINT
2
dhtypename
VARCHAR
32
literalprefix
VARCHAR
1
literalsuffix
VARCHAR
1
localtypename
VARCHAR
1
nullable
SMALLINT
2
odbcmoney
SMALLINT
2
searchable
SMALLINT
2
typeprecision
INTEGER
4
unsignedattr
SMALLINT
2


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095